The query benchmark tool allows users to better understand the time taken in processing requests in Discover. It includes an overview of the time spent on the query (on the data source), the processing time on Pyramid (both server and client) and the network.
Note: The Query Performance tool is only available to admins, and will only appear if the benchmark logging option has been enabled in the Admin Console. Benchmark logging, if enabled, has an impact on performance.
Query Performance Overview
After the feature has been enabled in the admin, the user will see a Clock icon in the App Tab status bar when a green Discover tab is selected (or in focus). Click the Clock icon (green arrow below) to open the Performance dialog:
Metrics
Time Metrics
- Pyramid Time: The time spent before and after submitting the query in Pyramid's own processes. The time is further split between the client and the server components.
- Network: The time spent sending and retrieving a query's result across the network (or internet).
- Query Time: The time taken by the data source to respond to the request and provide results.
Result Size Metrics
Pyramid retrieves results in a tabular format (even if the final visualization is shown as a cross tabulation or chart). As such, the result sizes are shown in their raw tabular form:
- Columns: The number of columns retrieved in the result set. This may be more than the visible items in the query as it includes any peripheral data points needed to draw the result.
- Rows: The number of the rows retrieved in the result set.
- Cells: The number of the cells retrieved in the result set (rows x columns).
Query Text dialog
Click the Code icon </> (orange arrow above) at the top of the Performance dialog to open the Query Text dialog, where you can see the actual query (for both SQL and MDX) that was submitted to the data source for processing.
- Click here for more information